How to: Remove a sort order.
Solution:
Select the 'Records' menu and select 'Remove Filter/Sort'.
1)
If the Database window is not active,
activate the Database window.
2)
Open the table in the Table Datasheet view
.
3)
Select the 'Records' menu and select 'Remove Filter/Sort'. (The records return to the original order.)